CREATE TABLE [dbo].[ContactBiography]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[Summary] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Text] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsPublic] [bit] NOT NULL CONSTRAINT [DF_ContactBiography_IsPublic] DEFAULT ((0)),
[InBusinessSinceYear] [decimal] (4, 0) NULL,
[Locations] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_ContactBiography_UpdatedOn] DEFAULT (getdate()),
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[BiographyReferences] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContactBiography] ADD CONSTRAINT [PK_ContactBiography] PRIMARY KEY CLUSTERED ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContactBiography_UpdatedByUserKey] ON [dbo].[ContactBiography] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactBiography] ADD CONSTRAINT [FK_ContactBio_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[ContactBiography] ADD CONSTRAINT [FK_ContactBiography_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO